Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_611

R_611

Service

PerfService

ServID

 

 

R_660

R_660

Event

PerfService

EventID

 

 

R_1010

R_1010

Drainage

Surgery

DrainageID

 

 

R_1011

R_1011

Duration

Surgery

DurationID

 

 

R_1012

R_1012

Duration

DurationText

DurationID

 

 

R_1014

R_1014

BodyPart

BodyPartText

BodyPartID

 

 

R_1016

R_1016

Surgery

LSurgeryBodyPart

SurgeryID

 

 

R_1017

R_1017

Infection

Surgery

InfectionID

 

 

R_1018

R_1018

Service

Surgery

ServID

 

 

R_1019

R_1019

SurgeryType

SurgeryTypeText

SurgeryTypeID

 

 

R_1021

R_1021

SurgeryType

Surgery

SurgeryTypeID

 

 

R_1022

R_1022

SurgeryTechnique

SurgeryTechniqueText

SurgeryTechniqueID

 

 

R_1024

R_1024

Surgery

LSurgeryTechnique

SurgeryID

 

 

R_1025

R_1025

SurgeryTechnique

LSurgeryTechnique

SurgeryTechniqueID

 

 

R_1026

R_1026

AnaesteticType

AnaesteticTypeText

AnaesteticTypeID

 

 

R_1028

R_1028

Surgery

LSurgeryAnaesteticType

SurgeryID

 

 

R_1029

R_1029

AnaesteticType

LSurgeryAnaesteticType

AnaesteticTypeID

 

 

R_1030

R_1030

Drainage

DrainageText

DrainageID

 

 

R_1032

R_1032

Service

Examination

ServID

 

 

R_1033

R_1033

Infection

Examination

InfectionID

 

 

R_1036

R_1036

TreatmentType

TreatmentTypeText

TreatmentTypeID

 

 

R_1037

R_1037

TreatmentResult

TreatmentResultText

TreatmentResultID

 

 

R_1038

R_1038

TreatmentType

Treatment

TreatmentTypeID

 

 

R_1039

R_1039

TreatmentResult

Treatment

TreatmentResultID

 

 

R_1040

R_1040

Infection

Treatment

InfectionID

 

 

R_1041

R_1041

InfectionType

InfectionTypeText

InfectionTypeID

 

 

R_1043

R_1043

InfectionType

Infection

InfectionTypeID

 

 

R_1044

R_1044

BirthStage

BirthStageText

BirthStageID

 

 

R_1046

R_1046

BirthStage

Infection

BirthStageID

 

 

R_1047

R_1047

Symptom

SymptomText

SymptomID

 

 

R_1049

R_1049

Symptom

LInfectionSymptom

SymptomID

 

 

R_1050

R_1050

Infection

LInfectionSymptom

InfectionID

 

 

R_1051

R_1051

RiskFactor

RiskFactorText

RiskFactorID

 

 

R_1053

R_1053

RiskFactor

LInfectionRiskFactor

RiskFactorID

 

 

R_1054

R_1054

Infection

LInfectionRiskFactor

InfectionID

 

 

R_1055

R_1055

InfectionClass

Infection

InfectionClassID

 

 

R_1057

R_1057

InfectionKind

InfectionKindText

InfectionKindID

 

 

R_1059

R_1059

DeceaseIdentification

DeceaseIdentificationText

DeceaseIdentificationID

 

 

R_1060

R_1060

DeceaseIdentification

Infection

DeceaseIdentificationID

 

 

R_1061

R_1061

InfClinicalProcess

InfClinicalProcessText

InfClinicalProcessID

 

 

R_1063

R_1063

InfClinicalProcess

Infection

InfClinicalProcessID

 

 

R_1064

R_1064

InfectionKind

LInfectionKind

InfectionKindID

 

 

R_1065

R_1065

Infection

LInfectionBurdenFactor

InfectionID

 

 

R_1066

R_1066

BurdenFactor

LInfectionBurdenFactor

BurdenFactorID

 

 

R_1067

R_1067

BurdenFactor

BurdenFactorText

BurdenFactorID

 

 

R_1072

R_1072

CleannessLevel

Surgery

CleannessLevelID

 

 

R_1073

R_1073

CleannessLevel

CleannessLevelText

CleannessLevelID

 

 

R_1075

R_1075

AntibacterialProphylaxis

Surgery

AntibacterialProphylaxisID

 

 

R_1076

R_1076

AntibacterialProphylaxis

AntibacterialProphylaxisText

AntibacterialProphylaxisID

 

 

R_1078

R_1078

PerfService

Surgery

PerfServiceID

 

 


2  3